package com.bert.thymeleafgenerator.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;
import java.util.List;
import java.util.Map;

/**
 *
 * @author 
 * @since 2021-11-25
 */
public interface MokMapper extends BaseMapper {

    /**
     *  根据检测系统的ID获取船名航次
     * @return 船名*航次
     */
    @Options(statementType = StatementType.CALLABLE)
//    @Select("call get_zd_readonly('mode','v_xf_planitem_zd_yy',#{plamitemId,mode=IN},#{moduleIdName,mode=IN},#{zd,mode=OUT,jdbcType=INTEGER},#{ts,mode=OUT,jdbcType=VARCHAR})")
//    @Select("call getinfo(varchar bm, varchar qzzd, varchar tjzd, varchar tj)")
    @Select("call getinfo(#{bm,mode=IN}, #{qzzd,mode=IN}, #{tjzd,mode=IN}, #{tj,mode=IN})")
    List<Map<String, Object>> getZdReadonly(@Param("bm") String bm,@Param("qzzd") String qzzd,@Param("tjzd") String tjzd,@Param("tj") String tj);


}
